﻿CREATE PROCEDURE [acms].[Topic_GetAllBySiteId]
	@SiteId int
AS
	SELECT a.*
	FROM Topic_View a
		inner join TopicGroup_View b on a.TopicGroupId = b.Id
	WHERE b.SiteId = @SiteId
	ORDER BY TopicGroupName, Sequence

RETURN 0;